package com.system.user.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.system.user.entity.LightingEntity;
import com.system.user.entityVO.LightingVO;
import com.system.user.entityVO.WatchVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface LightingDao {

    List<LightingEntity> selectAll();

    List<LightingEntity> selectBySiteOrNumber(LightingEntity lightingEntity);

    List<LightingVO> selectByUId(@Param("uId") Integer uId, @Param("number") Integer number);

    List<LightingVO> findAllByBNumber(@Param("bNumber") String bNumber);

    List<WatchVO> queryWatchByUid(@Param("uid") Integer uid);

    List<WatchVO> queryOtherWatch(WatchVO watchVO);

    LightingEntity selectById(@Param("id") Integer id);

    String selectSiteByNumber(@Param("bNumber") String bNumber);

    int insertLighting(LightingEntity lightingEntity);

    int updateLighting(LightingEntity lightingEntity);

    int deleteLighting(@Param("id") Integer id);

}
